<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--NewPage-->
<HTML>
<HEAD>
<TITLE>
Finance (POI API Documentation)
</TITLE>

<META NAME="keywords" CONTENT="org.apache.poi.ss.formula.functions.Finance class">

<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../../stylesheet.css" TITLE="Style">

<SCRIPT type="text/javascript">
function windowTitle()
{
    parent.document.title="Finance (POI API Documentation)";
}
</SCRIPT>
<NOSCRIPT>
</NOSCRIPT>

</HEAD>

<BODY BGCOLOR="white" onload="windowTitle();">


<!-- ========= START OF TOP NAVBAR ======= -->
<A NAME="navbar_top"><!-- --></A>
<A HREF="#skip-navbar_top" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_top_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="class-use/Finance.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../../../org/apache/poi/ss/formula/functions/FactDouble.html" title="class in org.apache.poi.ss.formula.functions"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html" title="class in org.apache.poi.ss.formula.functions"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../../../index.html?org/apache/poi/ss/formula/functions/Finance.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="Finance.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_top"></A>
<!-- ========= END OF TOP NAVBAR ========= -->

<HR>
<!-- ======== START OF CLASS DATA ======== -->
<H2>
<FONT SIZE="-1">
org.apache.poi.ss.formula.functions</FONT>
<BR>
Class Finance</H2>
<PRE>
java.lang.Object
  <IMG SRC="../../../../../../resources/inherit.gif" ALT="extended by "><B>org.apache.poi.ss.formula.functions.Finance</B>
</PRE>
<HR>
<DL>
<DT><PRE>public class <B>Finance</B><DT>extends java.lang.Object</DL>
</PRE>

<P>
Implementation of the financial functions pmt, fv, ppmt, ipmt.
<P>

<P>
<HR>

<P>

<!-- ======== CONSTRUCTOR SUMMARY ======== -->

<A NAME="constructor_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Constructor Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#Finance()">Finance</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
</TABLE>
&nbsp;
<!-- ========== METHOD SUMMARY =========== -->

<A NAME="method_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Method Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#fv(double, int, double, double)">fv</A></B>(double&nbsp;r,
   int&nbsp;nper,
   double&nbsp;c,
   double&nbsp;pv)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Overloaded fv() call omitting type, which defaults to 0.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#fv(double, int, double, double, int)">fv</A></B>(double&nbsp;r,
   int&nbsp;nper,
   double&nbsp;pmt,
   double&nbsp;pv,
   int&nbsp;type)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Emulates Excel/Calc's FV(interest_rate, number_payments, payment, PV,
 Type) function, which calculates future value or principal at period N.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#ipmt(double, int, int, double)">ipmt</A></B>(double&nbsp;r,
     int&nbsp;per,
     int&nbsp;nper,
     double&nbsp;pv)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#ipmt(double, int, int, double, double)">ipmt</A></B>(double&nbsp;r,
     int&nbsp;per,
     int&nbsp;nper,
     double&nbsp;pv,
     double&nbsp;fv)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#ipmt(double, int, int, double, double, int)">ipmt</A></B>(double&nbsp;r,
     int&nbsp;per,
     int&nbsp;nper,
     double&nbsp;pv,
     double&nbsp;fv,
     int&nbsp;type)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Emulates Excel/Calc's IPMT(interest_rate, period, number_payments, PV,
 FV, Type) function, which calculates the portion of the payment at a
 given period that is the interest on previous balance.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#pmt(double, int, double)">pmt</A></B>(double&nbsp;r,
    int&nbsp;nper,
    double&nbsp;pv)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Overloaded pmt() call omitting fv and type, which both default to 0.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#pmt(double, int, double, double)">pmt</A></B>(double&nbsp;r,
    int&nbsp;nper,
    double&nbsp;pv,
    double&nbsp;fv)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Overloaded pmt() call omitting type, which defaults to 0.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#pmt(double, int, double, double, int)">pmt</A></B>(double&nbsp;r,
    int&nbsp;nper,
    double&nbsp;pv,
    double&nbsp;fv,
    int&nbsp;type)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Emulates Excel/Calc's PMT(interest_rate, number_payments, PV, FV, Type)
 function, which calculates the payments for a loan or the future value of an investment</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#ppmt(double, int, int, double)">ppmt</A></B>(double&nbsp;r,
     int&nbsp;per,
     int&nbsp;nper,
     double&nbsp;pv)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#ppmt(double, int, int, double, double)">ppmt</A></B>(double&nbsp;r,
     int&nbsp;per,
     int&nbsp;nper,
     double&nbsp;pv,
     double&nbsp;fv)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static&nbsp;double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#ppmt(double, int, int, double, double, int)">ppmt</A></B>(double&nbsp;r,
     int&nbsp;per,
     int&nbsp;nper,
     double&nbsp;pv,
     double&nbsp;fv,
     int&nbsp;type)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Emulates Excel/Calc's PPMT(interest_rate, period, number_payments, PV,
 FV, Type) function, which calculates the portion of the payment at a
 given period that will apply to principal.</TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Methods inherited from class java.lang.Object</B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</CODE></TD>
</TR>
</TABLE>
&nbsp;
<P>

<!-- ========= CONSTRUCTOR DETAIL ======== -->

<A NAME="constructor_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Constructor Detail</B></FONT></TH>
</TR>
</TABLE>

<A NAME="Finance()"><!-- --></A><H3>
Finance</H3>
<PRE>
public <B>Finance</B>()</PRE>
<DL>
</DL>

<!-- ============ METHOD DETAIL ========== -->

<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Method Detail</B></FONT></TH>
</TR>
</TABLE>

<A NAME="pmt(double, int, double, double, int)"><!-- --></A><H3>
pmt</H3>
<PRE>
public static double <B>pmt</B>(double&nbsp;r,
                         int&nbsp;nper,
                         double&nbsp;pv,
                         double&nbsp;fv,
                         int&nbsp;type)</PRE>
<DL>
<DD>Emulates Excel/Calc's PMT(interest_rate, number_payments, PV, FV, Type)
 function, which calculates the payments for a loan or the future value of an investment
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>r</CODE> - - periodic interest rate represented as a decimal.<DD><CODE>nper</CODE> - - number of total payments / periods.<DD><CODE>pv</CODE> - - present value -- borrowed or invested principal.<DD><CODE>fv</CODE> - - future value of loan or annuity.<DD><CODE>type</CODE> - - when payment is made: beginning of period is 1; end, 0.
<DT><B>Returns:</B><DD><code>double</code> representing periodic payment amount.</DL>
</DD>
</DL>
<HR>

<A NAME="pmt(double, int, double, double)"><!-- --></A><H3>
pmt</H3>
<PRE>
public static double <B>pmt</B>(double&nbsp;r,
                         int&nbsp;nper,
                         double&nbsp;pv,
                         double&nbsp;fv)</PRE>
<DL>
<DD>Overloaded pmt() call omitting type, which defaults to 0.
<P>
<DD><DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#pmt(double, int, double, double, int)"><CODE>pmt(double, int, double, double, int)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="pmt(double, int, double)"><!-- --></A><H3>
pmt</H3>
<PRE>
public static double <B>pmt</B>(double&nbsp;r,
                         int&nbsp;nper,
                         double&nbsp;pv)</PRE>
<DL>
<DD>Overloaded pmt() call omitting fv and type, which both default to 0.
<P>
<DD><DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#pmt(double, int, double, double, int)"><CODE>pmt(double, int, double, double, int)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="ipmt(double, int, int, double, double, int)"><!-- --></A><H3>
ipmt</H3>
<PRE>
public static double <B>ipmt</B>(double&nbsp;r,
                          int&nbsp;per,
                          int&nbsp;nper,
                          double&nbsp;pv,
                          double&nbsp;fv,
                          int&nbsp;type)</PRE>
<DL>
<DD>Emulates Excel/Calc's IPMT(interest_rate, period, number_payments, PV,
 FV, Type) function, which calculates the portion of the payment at a
 given period that is the interest on previous balance.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>r</CODE> - - periodic interest rate represented as a decimal.<DD><CODE>per</CODE> - - period (payment number) to check value at.<DD><CODE>nper</CODE> - - number of total payments / periods.<DD><CODE>pv</CODE> - - present value -- borrowed or invested principal.<DD><CODE>fv</CODE> - - future value of loan or annuity.<DD><CODE>type</CODE> - - when payment is made: beginning of period is 1; end, 0.
<DT><B>Returns:</B><DD><code>double</code> representing interest portion of payment.<DT><B>See Also:</B><DD><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#pmt(double, int, double, double, int)"><CODE>pmt(double, int, double, double, int)</CODE></A>, 
<A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#fv(double, int, double, double, int)"><CODE>fv(double, int, double, double, int)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="ipmt(double, int, int, double, double)"><!-- --></A><H3>
ipmt</H3>
<PRE>
public static double <B>ipmt</B>(double&nbsp;r,
                          int&nbsp;per,
                          int&nbsp;nper,
                          double&nbsp;pv,
                          double&nbsp;fv)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="ipmt(double, int, int, double)"><!-- --></A><H3>
ipmt</H3>
<PRE>
public static double <B>ipmt</B>(double&nbsp;r,
                          int&nbsp;per,
                          int&nbsp;nper,
                          double&nbsp;pv)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="ppmt(double, int, int, double, double, int)"><!-- --></A><H3>
ppmt</H3>
<PRE>
public static double <B>ppmt</B>(double&nbsp;r,
                          int&nbsp;per,
                          int&nbsp;nper,
                          double&nbsp;pv,
                          double&nbsp;fv,
                          int&nbsp;type)</PRE>
<DL>
<DD>Emulates Excel/Calc's PPMT(interest_rate, period, number_payments, PV,
 FV, Type) function, which calculates the portion of the payment at a
 given period that will apply to principal.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>r</CODE> - - periodic interest rate represented as a decimal.<DD><CODE>per</CODE> - - period (payment number) to check value at.<DD><CODE>nper</CODE> - - number of total payments / periods.<DD><CODE>pv</CODE> - - present value -- borrowed or invested principal.<DD><CODE>fv</CODE> - - future value of loan or annuity.<DD><CODE>type</CODE> - - when payment is made: beginning of period is 1; end, 0.
<DT><B>Returns:</B><DD><code>double</code> representing principal portion of payment.<DT><B>See Also:</B><DD><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#pmt(double, int, double, double, int)"><CODE>pmt(double, int, double, double, int)</CODE></A>, 
<A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#ipmt(double, int, int, double, double, int)"><CODE>ipmt(double, int, int, double, double, int)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="ppmt(double, int, int, double, double)"><!-- --></A><H3>
ppmt</H3>
<PRE>
public static double <B>ppmt</B>(double&nbsp;r,
                          int&nbsp;per,
                          int&nbsp;nper,
                          double&nbsp;pv,
                          double&nbsp;fv)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="ppmt(double, int, int, double)"><!-- --></A><H3>
ppmt</H3>
<PRE>
public static double <B>ppmt</B>(double&nbsp;r,
                          int&nbsp;per,
                          int&nbsp;nper,
                          double&nbsp;pv)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="fv(double, int, double, double, int)"><!-- --></A><H3>
fv</H3>
<PRE>
public static double <B>fv</B>(double&nbsp;r,
                        int&nbsp;nper,
                        double&nbsp;pmt,
                        double&nbsp;pv,
                        int&nbsp;type)</PRE>
<DL>
<DD>Emulates Excel/Calc's FV(interest_rate, number_payments, payment, PV,
 Type) function, which calculates future value or principal at period N.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>r</CODE> - - periodic interest rate represented as a decimal.<DD><CODE>nper</CODE> - - number of total payments / periods.<DD><CODE>pmt</CODE> - - periodic payment amount.<DD><CODE>pv</CODE> - - present value -- borrowed or invested principal.<DD><CODE>type</CODE> - - when payment is made: beginning of period is 1; end, 0.
<DT><B>Returns:</B><DD><code>double</code> representing future principal value.</DL>
</DD>
</DL>
<HR>

<A NAME="fv(double, int, double, double)"><!-- --></A><H3>
fv</H3>
<PRE>
public static double <B>fv</B>(double&nbsp;r,
                        int&nbsp;nper,
                        double&nbsp;c,
                        double&nbsp;pv)</PRE>
<DL>
<DD>Overloaded fv() call omitting type, which defaults to 0.
<P>
<DD><DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../../org/apache/poi/ss/formula/functions/Finance.html#fv(double, int, double, double, int)"><CODE>fv(double, int, double, double, int)</CODE></A></DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>


<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="class-use/Finance.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../../../org/apache/poi/ss/formula/functions/FactDouble.html" title="class in org.apache.poi.ss.formula.functions"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html" title="class in org.apache.poi.ss.formula.functions"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../../../index.html?org/apache/poi/ss/formula/functions/Finance.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="Finance.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->

<HR>

                <i>Copyright 2014 The Apache Software Foundation or
        its licensors, as applicable.</i>
            
</BODY>
</HTML>
